package com.droowa.model.dao;

import java.sql.SQLException;
import java.util.List;

import org.apache.ibatis.session.SqlSessionException;

import com.droowa.domain.Customer;
import com.droowa.domain.CustomerOut;

public interface CustomerDAO {


	public abstract int insertCustomer(Customer customer) throws SQLException;
	
	public abstract Customer getCustomerById(String custId) throws SQLException;
	
	public abstract int updateCustomer(Customer customer) throws SQLException;
	
	public abstract int deleteCustomerById(String custId) throws SQLException;
	
	public abstract int insertRemoveCustomer(CustomerOut custOut) throws SQLException;
	
	public abstract List<CustomerOut> selectCustomerOutList() throws SQLException;
	
	public abstract CustomerOut getCustomerOutById(String custId) throws SQLException;
	
	public abstract int deleteCustomerOutById(String custId) throws SQLException;
	
	public abstract List<Customer> selectCustomerList() throws SQLException;
	
	public abstract List<Customer> selectCustomerListByName(String name) throws SQLException;
	
	public abstract List<Customer> selectCustomerListByBirth(String birth) throws SQLException;
	
	public abstract List<Customer> selectCustomerListByPhone(String phone) throws SQLException;
	
	public abstract List<Customer> selectCustomerListByAddress(String address) throws SQLException;
	
	public abstract List<Customer> selectCustomerListByJoinDate(String joinDate) throws SQLException;
	
	
}
